// Add FIPS codes for OH counties
// source: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697
gen fcounty=.
replace fcounty=1 if county=="Adams" & state=="Ohio"
replace fcounty=3 if county=="Allen" & state=="Ohio"
replace fcounty=5 if county=="Ashland" & state=="Ohio"
replace fcounty=7 if county=="Ashtabula" & state=="Ohio"
replace fcounty=9 if county=="Athens" & state=="Ohio"
replace fcounty=11 if county=="Auglaize" & state=="Ohio"
replace fcounty=13 if county=="Belmont" & state=="Ohio"
replace fcounty=15 if county=="Brown" & state=="Ohio"
replace fcounty=17 if county=="Butler" & state=="Ohio"
replace fcounty=19 if county=="Carroll" & state=="Ohio"
replace fcounty=21 if county=="Champaign" & state=="Ohio"
replace fcounty=23 if county=="Clark" & state=="Ohio"
replace fcounty=25 if county=="Clermont" & state=="Ohio"
replace fcounty=27 if county=="Clinton" & state=="Ohio"
replace fcounty=29 if county=="Columbiana" & state=="Ohio"
replace fcounty=31 if county=="Coshocton" & state=="Ohio"
replace fcounty=33 if county=="Crawford" & state=="Ohio"
replace fcounty=35 if county=="Cuyahoga" & state=="Ohio"
replace fcounty=37 if county=="Darke" & state=="Ohio"
replace fcounty=39 if county=="Defiance" & state=="Ohio"
replace fcounty=41 if county=="Delaware" & state=="Ohio"
replace fcounty=43 if county=="Erie" & state=="Ohio"
replace fcounty=45 if county=="Fairfield" & state=="Ohio"
replace fcounty=47 if county=="Fayette" & state=="Ohio"
replace fcounty=49 if county=="Franklin" & state=="Ohio"
replace fcounty=51 if county=="Fulton" & state=="Ohio"
replace fcounty=53 if county=="Gallia" & state=="Ohio"
replace fcounty=55 if county=="Geauga" & state=="Ohio"
replace fcounty=57 if county=="Greene" & state=="Ohio"
replace fcounty=59 if county=="Guernsey" & state=="Ohio"
replace fcounty=61 if county=="Hamilton" & state=="Ohio"
replace fcounty=63 if county=="Hancock" & state=="Ohio"
replace fcounty=65 if county=="Hardin" & state=="Ohio"
replace fcounty=67 if county=="Harrison" & state=="Ohio"
replace fcounty=69 if county=="Henry" & state=="Ohio"
replace fcounty=71 if county=="Highland" & state=="Ohio"
replace fcounty=73 if county=="Hocking" & state=="Ohio"
replace fcounty=75 if county=="Holmes" & state=="Ohio"
replace fcounty=77 if county=="Huron" & state=="Ohio"
replace fcounty=79 if county=="Jackson" & state=="Ohio"
replace fcounty=81 if county=="Jefferson" & state=="Ohio"
replace fcounty=83 if county=="Knox" & state=="Ohio"
replace fcounty=85 if county=="Lake" & state=="Ohio"
replace fcounty=87 if county=="Lawrence" & state=="Ohio"
replace fcounty=89 if county=="Licking" & state=="Ohio"
replace fcounty=91 if county=="Logan" & state=="Ohio"
replace fcounty=93 if county=="Lorain" & state=="Ohio"
replace fcounty=95 if county=="Lucas" & state=="Ohio"
replace fcounty=97 if county=="Madison" & state=="Ohio"
replace fcounty=99 if county=="Mahoning" & state=="Ohio"
replace fcounty=101 if county=="Marion" & state=="Ohio"
replace fcounty=103 if county=="Medina" & state=="Ohio"
replace fcounty=105 if county=="Meigs" & state=="Ohio"
replace fcounty=107 if county=="Mercer" & state=="Ohio"
replace fcounty=109 if county=="Miami" & state=="Ohio"
replace fcounty=111 if county=="Monroe" & state=="Ohio"
replace fcounty=113 if county=="Montgomery" & state=="Ohio"
replace fcounty=115 if county=="Morgan" & state=="Ohio"
replace fcounty=117 if county=="Morrow" & state=="Ohio"
replace fcounty=119 if county=="Muskingum" & state=="Ohio"
replace fcounty=121 if county=="Noble" & state=="Ohio"
replace fcounty=123 if county=="Ottawa" & state=="Ohio"
replace fcounty=125 if county=="Paulding" & state=="Ohio"
replace fcounty=127 if county=="Perry" & state=="Ohio"
replace fcounty=129 if county=="Pickaway" & state=="Ohio"
replace fcounty=131 if county=="Pike" & state=="Ohio"
replace fcounty=133 if county=="Portage" & state=="Ohio"
replace fcounty=135 if county=="Preble" & state=="Ohio"
replace fcounty=137 if county=="Putnam" & state=="Ohio"
replace fcounty=139 if county=="Richland" & state=="Ohio"
replace fcounty=141 if county=="Ross" & state=="Ohio"
replace fcounty=143 if county=="Sandusky" & state=="Ohio"
replace fcounty=145 if county=="Scioto" & state=="Ohio"
replace fcounty=147 if county=="Seneca" & state=="Ohio"
replace fcounty=149 if county=="Shelby" & state=="Ohio"
replace fcounty=151 if county=="Stark" & state=="Ohio"
replace fcounty=153 if county=="Summit" & state=="Ohio"
replace fcounty=155 if county=="Trumbull" & state=="Ohio"
replace fcounty=157 if county=="Tuscarawas" & state=="Ohio"
replace fcounty=159 if county=="Union" & state=="Ohio"
replace fcounty=161 if county=="Van Wert" & state=="Ohio"
replace fcounty=163 if county=="Vinton" & state=="Ohio"
replace fcounty=165 if county=="Warren" & state=="Ohio"
replace fcounty=167 if county=="Washington" & state=="Ohio"
replace fcounty=169 if county=="Wayne" & state=="Ohio"
replace fcounty=171 if county=="Williams" & state=="Ohio"
replace fcounty=173 if county=="Wood" & state=="Ohio"
replace fcounty=175 if county=="Wyandot" & state=="Ohio"
